drop table jms_dm.dm_route_whole_monitor_dt;
create external table jms_dm.dm_route_whole_monitor_dt (
   date_time     date   comment '数据日期',
   task_name     string comment '任务中文名称',
   database_name string comment '数据库名',
   table_name    string comment '数据表名称',
   t_data_sum    bigint comment '今天的数据量',
   y_data_sum    bigint comment '昨日数据量',
   is_push       int    comment '是否推送 1是2否'
) COMMENT '路由监控'
PARTITIONED BY (dt STRING COMMENT '日期分区')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_route_whole_monitor_dt'
TBLPROPERTIES (
'discover.partitions'='false',
'parquet.column.index.access'='true'
);